﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="gamesdbDataSet" targetNamespace="http://tempuri.org/gamesdbDataSet.xsd" xmlns:mstns="http://tempuri.org/gamesdbDataSet.xsd" xmlns="http://tempuri.org/gamesdbDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="gamesdbConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="gamesdbConnectionString (Settings)" PropertyReference="ApplicationSettings.WGM.Properties.Settings.GlobalReference.Default.gamesdbConnectionString" Provider="System.Data.OleDb" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="gamecentralTableAdapter" GeneratorDataComponentClassName="gamecentralTableAdapter" Name="gamecentral" UserDataComponentName="gamecentralTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="gamesdbConnectionString (Settings)" DbObjectName="gamecentral" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `gamecentral` WHERE ((`ID` = ?) AND ((? = 1 AND `gamename` IS NULL) OR (`gamename` = ?)) AND ((? = 1 AND `gamecompatibility` IS NULL) OR (`gamecompatibility` = ?)) AND ((? = 1 AND `backupable` IS NULL) OR (`backupable` = ?)) AND ((? = 1 AND `gamestatus` IS NULL) OR (`gamestatus` = ?)) AND ((? = 1 AND `gametype` IS NULL) OR (`gametype` = ?)) AND ((? = 1 AND `reviewnote` IS NULL) OR (`reviewnote` = ?)) AND ((? = 1 AND `lastplayed` IS NULL) OR (`lastplayed` = ?)) AND ((? = 1 AND `completed` IS NULL) OR (`completed` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_gamename" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="gamename" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_gamename" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamename" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_gamecompatibility" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="gamecompatibility" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_gamecompatibility" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamecompatibility" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_backupable" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="backupable" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_backupable" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="backupable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_gamestatus" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="gamestatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_gamestatus" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamestatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_gametype" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="gametype" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_gametype" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gametype" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_reviewnote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="reviewnote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_reviewnote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="reviewnote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_lastplayed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="lastplayed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_lastplayed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="lastplayed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_completed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="completed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_completed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="completed" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `gamecentral` (`gamename`, `savegamepath`, `gamecompatibility`, `backupable`, `gamestatus`, `gametype`, `reviewnote`, `reviewplus`, `reviewmoin`, `gamedescription`, `pathtogame`, `lastplayed`, `completed`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gamename" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="savegamepath" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="savegamepath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gamecompatibility" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamecompatibility" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="backupable" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="backupable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gamestatus" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamestatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gametype" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gametype" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="reviewnote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="reviewnote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="reviewplus" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="reviewplus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="reviewmoin" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="reviewmoin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gamedescription" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="gamedescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="pathtogame" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="pathtogame" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="lastplayed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="lastplayed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="completed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="completed" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, gamename, savegamepath, gamecompatibility, backupable, gamestatus, gametype, reviewnote, reviewplus, reviewmoin, gamedescription, pathtogame, lastplayed, completed FROM gamecentral</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `gamecentral` SET `gamename` = ?, `savegamepath` = ?, `gamecompatibility` = ?, `backupable` = ?, `gamestatus` = ?, `gametype` = ?, `reviewnote` = ?, `reviewplus` = ?, `reviewmoin` = ?, `gamedescription` = ?, `pathtogame` = ?, `lastplayed` = ?, `completed` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `gamename` IS NULL) OR (`gamename` = ?)) AND ((? = 1 AND `gamecompatibility` IS NULL) OR (`gamecompatibility` = ?)) AND ((? = 1 AND `backupable` IS NULL) OR (`backupable` = ?)) AND ((? = 1 AND `gamestatus` IS NULL) OR (`gamestatus` = ?)) AND ((? = 1 AND `gametype` IS NULL) OR (`gametype` = ?)) AND ((? = 1 AND `reviewnote` IS NULL) OR (`reviewnote` = ?)) AND ((? = 1 AND `lastplayed` IS NULL) OR (`lastplayed` = ?)) AND ((? = 1 AND `completed` IS NULL) OR (`completed` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gamename" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamename" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="savegamepath" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="savegamepath" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gamecompatibility" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamecompatibility" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="backupable" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="backupable" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gamestatus" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamestatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gametype" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gametype" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="reviewnote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="reviewnote" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="reviewplus" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="reviewplus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="reviewmoin" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="reviewmoin" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gamedescription" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="gamedescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="pathtogame" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="pathtogame" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="lastplayed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="lastplayed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="completed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="completed" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_gamename" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="gamename" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_gamename" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamename" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_gamecompatibility" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="gamecompatibility" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_gamecompatibility" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamecompatibility" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_backupable" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="backupable" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_backupable" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="backupable" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_gamestatus" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="gamestatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_gamestatus" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamestatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_gametype" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="gametype" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_gametype" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gametype" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_reviewnote" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="reviewnote" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_reviewnote" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="reviewnote" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_lastplayed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="lastplayed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_lastplayed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="lastplayed" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_completed" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="completed" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_completed" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="completed" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="gamename" DataSetColumn="gamename" />
              <Mapping SourceColumn="savegamepath" DataSetColumn="savegamepath" />
              <Mapping SourceColumn="gamecompatibility" DataSetColumn="gamecompatibility" />
              <Mapping SourceColumn="backupable" DataSetColumn="backupable" />
              <Mapping SourceColumn="gamestatus" DataSetColumn="gamestatus" />
              <Mapping SourceColumn="gametype" DataSetColumn="gametype" />
              <Mapping SourceColumn="reviewnote" DataSetColumn="reviewnote" />
              <Mapping SourceColumn="reviewplus" DataSetColumn="reviewplus" />
              <Mapping SourceColumn="reviewmoin" DataSetColumn="reviewmoin" />
              <Mapping SourceColumn="gamedescription" DataSetColumn="gamedescription" />
              <Mapping SourceColumn="pathtogame" DataSetColumn="pathtogame" />
              <Mapping SourceColumn="lastplayed" DataSetColumn="lastplayed" />
              <Mapping SourceColumn="completed" DataSetColumn="completed" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="timetrackTableAdapter" GeneratorDataComponentClassName="timetrackTableAdapter" Name="timetrack" UserDataComponentName="timetrackTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="gamesdbConnectionString (Settings)" DbObjectName="timetrack" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM `timetrack` WHERE ((`ID` = ?) AND ((? = 1 AND `gamelink` IS NULL) OR (`gamelink` = ?)) AND ((? = 1 AND `sessiontime` IS NULL) OR (`sessiontime` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_gamelink" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="gamelink" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_gamelink" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamelink" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_sessiontime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sessiontime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_sessiontime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sessiontime" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO `timetrack` (`gamelink`, `sessiontime`) VALUES (?, ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gamelink" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamelink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="sessiontime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sessiontime" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ID, gamelink, sessiontime FROM timetrack</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE `timetrack` SET `gamelink` = ?, `sessiontime` = ? WHERE ((`ID` = ?) AND ((? = 1 AND `gamelink` IS NULL) OR (`gamelink` = ?)) AND ((? = 1 AND `sessiontime` IS NULL) OR (`sessiontime` = ?)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="gamelink" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamelink" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="sessiontime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sessiontime" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_ID" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="ID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_gamelink" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="gamelink" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Original_gamelink" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="gamelink" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="IsNull_sessiontime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sessiontime" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_sessiontime" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="sessiontime" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ID" DataSetColumn="ID" />
              <Mapping SourceColumn="gamelink" DataSetColumn="gamelink" />
              <Mapping SourceColumn="sessiontime" DataSetColumn="sessiontime" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="gamesdbDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="gamesdbDataSet" msprop:Generator_UserDSName="gamesdbDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="gamecentral" msprop:Generator_TableClassName="gamecentralDataTable" msprop:Generator_TableVarName="tablegamecentral" msprop:Generator_TablePropName="gamecentral" msprop:Generator_RowDeletingName="gamecentralRowDeleting" msprop:Generator_RowChangingName="gamecentralRowChanging" msprop:Generator_RowEvHandlerName="gamecentralRowChangeEventHandler" msprop:Generator_RowDeletedName="gamecentralRowDeleted" msprop:Generator_UserTableName="gamecentral" msprop:Generator_RowChangedName="gamecentralRowChanged" msprop:Generator_RowEvArgName="gamecentralRowChangeEvent" msprop:Generator_RowClassName="gamecentralRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="gamename" msprop:Generator_ColumnVarNameInTable="columngamename" msprop:Generator_ColumnPropNameInRow="gamename" msprop:Generator_ColumnPropNameInTable="gamenameColumn" msprop:Generator_UserColumnName="gamename" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="savegamepath" msprop:Generator_ColumnVarNameInTable="columnsavegamepath" msprop:Generator_ColumnPropNameInRow="savegamepath" msprop:Generator_ColumnPropNameInTable="savegamepathColumn" msprop:Generator_UserColumnName="savegamepath" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gamecompatibility" msprop:Generator_ColumnVarNameInTable="columngamecompatibility" msprop:Generator_ColumnPropNameInRow="gamecompatibility" msprop:Generator_ColumnPropNameInTable="gamecompatibilityColumn" msprop:Generator_UserColumnName="gamecompatibility" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="backupable" msprop:Generator_ColumnVarNameInTable="columnbackupable" msprop:Generator_ColumnPropNameInRow="backupable" msprop:Generator_ColumnPropNameInTable="backupableColumn" msprop:Generator_UserColumnName="backupable" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gamestatus" msprop:Generator_ColumnVarNameInTable="columngamestatus" msprop:Generator_ColumnPropNameInRow="gamestatus" msprop:Generator_ColumnPropNameInTable="gamestatusColumn" msprop:Generator_UserColumnName="gamestatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gametype" msprop:Generator_ColumnVarNameInTable="columngametype" msprop:Generator_ColumnPropNameInRow="gametype" msprop:Generator_ColumnPropNameInTable="gametypeColumn" msprop:Generator_UserColumnName="gametype" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="reviewnote" msprop:Generator_ColumnVarNameInTable="columnreviewnote" msprop:Generator_ColumnPropNameInRow="reviewnote" msprop:Generator_ColumnPropNameInTable="reviewnoteColumn" msprop:Generator_UserColumnName="reviewnote" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="reviewplus" msprop:Generator_ColumnVarNameInTable="columnreviewplus" msprop:Generator_ColumnPropNameInRow="reviewplus" msprop:Generator_ColumnPropNameInTable="reviewplusColumn" msprop:Generator_UserColumnName="reviewplus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="reviewmoin" msprop:Generator_ColumnVarNameInTable="columnreviewmoin" msprop:Generator_ColumnPropNameInRow="reviewmoin" msprop:Generator_ColumnPropNameInTable="reviewmoinColumn" msprop:Generator_UserColumnName="reviewmoin" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="gamedescription" msprop:Generator_ColumnVarNameInTable="columngamedescription" msprop:Generator_ColumnPropNameInRow="gamedescription" msprop:Generator_ColumnPropNameInTable="gamedescriptionColumn" msprop:Generator_UserColumnName="gamedescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="pathtogame" msprop:Generator_ColumnVarNameInTable="columnpathtogame" msprop:Generator_ColumnPropNameInRow="pathtogame" msprop:Generator_ColumnPropNameInTable="pathtogameColumn" msprop:Generator_UserColumnName="pathtogame" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lastplayed" msprop:Generator_ColumnVarNameInTable="columnlastplayed" msprop:Generator_ColumnPropNameInRow="lastplayed" msprop:Generator_ColumnPropNameInTable="lastplayedColumn" msprop:Generator_UserColumnName="lastplayed" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="completed" msprop:Generator_ColumnVarNameInTable="columncompleted" msprop:Generator_ColumnPropNameInRow="completed" msprop:Generator_ColumnPropNameInTable="completedColumn" msprop:Generator_UserColumnName="completed" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="timetrack" msprop:Generator_TableClassName="timetrackDataTable" msprop:Generator_TableVarName="tabletimetrack" msprop:Generator_TablePropName="timetrack" msprop:Generator_RowDeletingName="timetrackRowDeleting" msprop:Generator_RowChangingName="timetrackRowChanging" msprop:Generator_RowEvHandlerName="timetrackRowChangeEventHandler" msprop:Generator_RowDeletedName="timetrackRowDeleted" msprop:Generator_UserTableName="timetrack" msprop:Generator_RowChangedName="timetrackRowChanged" msprop:Generator_RowEvArgName="timetrackRowChangeEvent" msprop:Generator_RowClassName="timetrackRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnID" msprop:Generator_ColumnPropNameInRow="ID" msprop:Generator_ColumnPropNameInTable="IDColumn" msprop:Generator_UserColumnName="ID" type="xs:int" />
              <xs:element name="gamelink" msprop:Generator_ColumnVarNameInTable="columngamelink" msprop:Generator_ColumnPropNameInRow="gamelink" msprop:Generator_ColumnPropNameInTable="gamelinkColumn" msprop:Generator_UserColumnName="gamelink" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sessiontime" msprop:Generator_ColumnVarNameInTable="columnsessiontime" msprop:Generator_ColumnPropNameInRow="sessiontime" msprop:Generator_ColumnPropNameInTable="sessiontimeColumn" msprop:Generator_UserColumnName="sessiontime" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:gamecentral" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
    <xs:unique name="timetrack_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:timetrack" />
      <xs:field xpath="mstns:ID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="gamecentraltimetrack" msdata:parent="gamecentral" msdata:child="timetrack" msdata:parentkey="gamename" msdata:childkey="gamelink" msprop:Generator_UserChildTable="timetrack" msprop:Generator_ChildPropName="GettimetrackRows" msprop:Generator_UserRelationName="gamecentraltimetrack" msprop:Generator_ParentPropName="gamecentralRow" msprop:Generator_RelationVarName="relationgamecentraltimetrack" msprop:Generator_UserParentTable="gamecentral" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>